Use nerddinner
GO

CREATE TABLE [Dinners](
	[DinnerID] [int] IDENTITY(1,1) primary key,
	[Title] [nvarchar](50) NOT NULL,
	[EventDate] [datetime] NOT NULL,
	[Description] [nvarchar](256) NOT NULL,
	[HostedBy] [nvarchar](20) NOT NULL,
	[ContactPhone] [nvarchar](20) NOT NULL,
	[Address] [nvarchar](20) NOT NULL,
	[Country] [nvarchar](30) NOT NULL,
	[Latitude] [float] NOT NULL,
	[Longitude] [float] NOT NULL)
GO


CREATE TABLE [RSVP](
	[RsvpID] [int] IDENTITY(1,1) Primary key,
	[DinnerID] [int] References Dinners (DinnerId),
	[AttendeeName] [nvarchar](30) NOT NULL)

GO